﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'ThreeConcurrent_View')
BEGIN
	DROP  View ThreeConcurrent_View
END
GO
CREATE View ThreeConcurrent_View AS
SELECT A.*,B.EnterpriseName,B.Addess FROM ThreeConcurrent A 
JOIN Enterprises_View B ON A.EnterpriseID=B.EnterpriseID
GO
